package com.xm.settlement.commons.base;

import java.sql.DriverManager;
import java.util.Iterator;
import java.util.NoSuchElementException;
import java.util.concurrent.atomic.AtomicReferenceFieldUpdater;

/**
 * Created by Administrator on 2017/3/3.
 * 自定义拓展SQL异常部分
 */
public class ApiSQLException extends Exception  implements Iterable<Throwable> {

    private Integer code;

    public ApiSQLException(Integer code,String reason, String SQLState, int vendorCode) {
            super(reason);
            this.code = code;
            this.SQLState = SQLState;
            this.vendorCode = vendorCode;
            if (!(this instanceof ApiSQLWarning)) {
                if (DriverManager.getLogWriter() != null) {
                    DriverManager.println("SQLState(" + SQLState +
                            ") vendor code(" + vendorCode + ")");
                    printStackTrace(DriverManager.getLogWriter());
                }
            }
    }


    public ApiSQLException(Integer code ,String reason, String SQLState) {
        super(reason);
        this.code = code;
        this.SQLState = SQLState;
        this.vendorCode = 0;
        if (!(this instanceof ApiSQLWarning)) {
            if (DriverManager.getLogWriter() != null) {
                printStackTrace(DriverManager.getLogWriter());
                DriverManager.println("SQLException: SQLState(" + SQLState + ")");
            }
        }
    }

    /**
     *  Constructs a <code>SQLException</code> object with a given
     * <code>reason</code>. The  <code>SQLState</code>  is initialized to
     * <code>null</code> and the vendor code is initialized to 0.
     *
     * The <code>cause</code> is not initialized, and may subsequently be
     * initialized by a call to the
     * {@link Throwable#initCause(Throwable)} method.
     * <p>
     * @param reason a description of the exception
     */
    public ApiSQLException(Integer code,String reason) {
        super(reason);
        this.code = code;
        this.SQLState = null;
        this.vendorCode = 0;
        if (!(this instanceof ApiSQLWarning)) {
            if (DriverManager.getLogWriter() != null) {
                printStackTrace(DriverManager.getLogWriter());
            }
        }
    }

    /**
     * Constructs a <code>SQLException</code> object.
     * The <code>reason</code>, <code>SQLState</code> are initialized
     * to <code>null</code> and the vendor code is initialized to 0.
     *
     * The <code>cause</code> is not initialized, and may subsequently be
     * initialized by a call to the
     * {@link Throwable#initCause(Throwable)} method.
     *
     */
    public ApiSQLException() {
        super();
        this.SQLState = null;
        this.vendorCode = 0;
        if (!(this instanceof ApiSQLWarning)) {
            if (DriverManager.getLogWriter() != null) {
                printStackTrace(DriverManager.getLogWriter());
            }
        }
    }

    /**
     *  Constructs a <code>SQLException</code> object with a given
     * <code>cause</code>.
     * The <code>SQLState</code> is initialized
     * to <code>null</code> and the vendor code is initialized to 0.
     * The <code>reason</code>  is initialized to <code>null</code> if
     * <code>cause==null</code> or to <code>cause.toString()</code> if
     * <code>cause!=null</code>.
     * <p>
     * @param cause the underlying reason for this <code>SQLException</code>
     * (which is saved for later retrieval by the <code>getCause()</code> method);
     * may be null indicating the cause is non-existent or unknown.
     * @since 1.6
     */
    public ApiSQLException(Throwable cause) {
        super(cause);

        if (!(this instanceof ApiSQLWarning)) {
            if (DriverManager.getLogWriter() != null) {
                printStackTrace(DriverManager.getLogWriter());
            }
        }
    }

    public ApiSQLException(Integer code,String reason, Throwable cause) {
        super(reason,cause);
        this.code = code ;
        if (!(this instanceof ApiSQLWarning)) {
            if (DriverManager.getLogWriter() != null) {
                printStackTrace(DriverManager.getLogWriter());
            }
        }
    }

    /**
     * Constructs a <code>SQLException</code> object with a given
     * <code>reason</code> and  <code>cause</code>.
     * The <code>SQLState</code> is  initialized to <code>null</code>
     * and the vendor code is initialized to 0.
     * <p>
     * @param reason a description of the exception.
     * @param cause the underlying reason for this <code>SQLException</code>
     * (which is saved for later retrieval by the <code>getCause()</code> method);
     * may be null indicating the cause is non-existent or unknown.
     * @since 1.6
     */
    public ApiSQLException(String reason, Throwable cause) {
        super(reason,cause);

        if (!(this instanceof ApiSQLWarning)) {
            if (DriverManager.getLogWriter() != null) {
                printStackTrace(DriverManager.getLogWriter());
            }
        }
    }

    /**
     * Constructs a <code>SQLException</code> object with a given
     * <code>reason</code>, <code>SQLState</code> and  <code>cause</code>.
     * The vendor code is initialized to 0.
     * <p>
     * @param reason a description of the exception.
     * @param sqlState an XOPEN or SQL:2003 code identifying the exception
     * @param cause the underlying reason for this <code>SQLException</code>
     * (which is saved for later retrieval by the
     * <code>getCause()</code> method); may be null indicating
     *     the cause is non-existent or unknown.
     * @since 1.6
     */
    public ApiSQLException(String reason, String sqlState, Throwable cause) {
        super(reason,cause);

        this.SQLState = sqlState;
        this.vendorCode = 0;
        if (!(this instanceof ApiSQLWarning)) {
            if (DriverManager.getLogWriter() != null) {
                printStackTrace(DriverManager.getLogWriter());
                DriverManager.println("SQLState(" + SQLState + ")");
            }
        }
    }

    /**
     * Constructs a <code>SQLException</code> object with a given
     * <code>reason</code>, <code>SQLState</code>, <code>vendorCode</code>
     * and  <code>cause</code>.
     * <p>
     * @param reason a description of the exception
     * @param sqlState an XOPEN or SQL:2003 code identifying the exception
     * @param vendorCode a database vendor-specific exception code
     * @param cause the underlying reason for this <code>SQLException</code>
     * (which is saved for later retrieval by the <code>getCause()</code> method);
     * may be null indicating the cause is non-existent or unknown.
     * @since 1.6
     */
    public ApiSQLException(String reason, String sqlState, int vendorCode, Throwable cause) {
        super(reason,cause);

        this.SQLState = sqlState;
        this.vendorCode = vendorCode;
        if (!(this instanceof ApiSQLWarning)) {
            if (DriverManager.getLogWriter() != null) {
                DriverManager.println("SQLState(" + SQLState +
                        ") vendor code(" + vendorCode + ")");
                printStackTrace(DriverManager.getLogWriter());
            }
        }
    }

    /**
     * Retrieves the SQLState for this <code>SQLException</code> object.
     *
     * @return the SQLState value
     */
    public String getSQLState() {
        return (SQLState);
    }

    /**
     * Retrieves the vendor-specific exception code
     * for this <code>SQLException</code> object.
     *
     * @return the vendor's error code
     */
    public int getErrorCode() {
        return (vendorCode);
    }

    /**
     * Retrieves the exception chained to this
     * <code>SQLException</code> object by setNextException(SQLException ex).
     *
     * @return the next <code>SQLException</code> object in the chain;
     *         <code>null</code> if there are none
     * @see #setNextException
     */
    public ApiSQLException getNextException() {
        return (next);
    }

    /**
     * Adds an <code>SQLException</code> object to the end of the chain.
     *
     * @param ex the new exception that will be added to the end of
     *            the <code>SQLException</code> chain
     * @see #getNextException
     */
    public void setNextException(ApiSQLWarning ex) {

        ApiSQLException current = this;
        for(;;) {
            ApiSQLException next = current.next;
            if (next != null) {
                current = next;
                continue;
            }

            if (nextUpdater.compareAndSet(current,null,ex)) {
                return;
            }
            current=current.next;
        }
    }

    /**
     * Returns an iterator over the chained SQLExceptions.  The iterator will
     * be used to iterate over each SQLException and its underlying cause
     * (if any).
     *
     * @return an iterator over the chained SQLExceptions and causes in the proper
     * order
     *
     * @since 1.6
     */
    public Iterator<Throwable> iterator() {

        return new Iterator<Throwable>() {

            ApiSQLException firstException = ApiSQLException.this;
            ApiSQLException nextException = firstException.getNextException();
            Throwable cause = firstException.getCause();

            public boolean hasNext() {
                if(firstException != null || nextException != null || cause != null)
                    return true;
                return false;
            }

            public Throwable next() {
                Throwable throwable = null;
                if(firstException != null){
                    throwable = firstException;
                    firstException = null;
                }
                else if(cause != null){
                    throwable = cause;
                    cause = cause.getCause();
                }
                else if(nextException != null){
                    throwable = nextException;
                    cause = nextException.getCause();
                    nextException = nextException.getNextException();
                }
                else
                    throw new NoSuchElementException();
                return throwable;
            }

            public void remove() {
                throw new UnsupportedOperationException();
            }

        };

    }

    /**
     * @serial
     */
    private String SQLState;

    /**
     * @serial
     */
    private int vendorCode;

    /**
     * @serial
     */
    private volatile ApiSQLException next;

    private static final AtomicReferenceFieldUpdater<ApiSQLException,ApiSQLException> nextUpdater =
            AtomicReferenceFieldUpdater.newUpdater(ApiSQLException.class,ApiSQLException.class,"next");

    private static final long serialVersionUID = 2135244094396331484L;


    public Integer getCode() {
        return code;
    }

    public void setCode(Integer code) {
        this.code = code;
    }
}
